Introduction

jumbotron

Employee Experience Report

Microsoft Viva | Organisational Insights


Based on decades of quantitative and qualitative research, and our own experience working with global customers and here within Microsoft, we have identified six key elements to a great employee experience. These elements are Strongly related to company outcomes, are predictive of lower turnover and are the foundations to a strong corporate culture.


This is a framework for evaluating Employee Experience. The main components of the baseline are as follows:

Start exploring


Overview

Row

Total

Row

Wellbeing

Empowerment

Connection

Row

Growth

Focus

Purpose

Baseline

Row

Title-Placeholder

Which teams could use further support to improve overall employee experience?

Row

Baseline

KPIs

Row

Title-Placeholder

Which underlying behaviours are impacting the employee experience pillar scores?

Row

KPIs

Opportunities

Row

Title-Placeholder

What are the behavioural opportunities for growth within each team?

Row

Opportunities

Distribution

Row

Title-Placeholder

Are employees within individual teams sharing a broadly uniform experience?

Row

Distribution

Notes

Column {data-height=650}

Query Spec

Specifications

Run a single daily person query:

  • Group by Day
  • At least 3 months
  • Ensure that IsActive flag is not applied

All metrics

Note: Custom metrics shown in bolded italics

  1. Meeting hours 1 on 1 [SEE SPEC BELOW]
  2. Meeting hours 1 on 1 with same level [SEE SPEC BELOW]
  3. Time in self organized meetings
  4. Open 2 hour blocks
  5. Collaboration hours external
  6. Meetings with skip level
  7. Meeting hours with skip level
  8. Meeting hours 3 to 8 [SEE SPEC BELOW]
  9. Internal network size
  10. Meeting hours with manager
  11. Meeting hours
  12. Meetings
  13. Meetings with manager
  14. Meeting hours with manager 1 on 1
  15. Instant messages sent
  16. Emails sent
  17. Workweek span
  18. Collaboration hours
  19. Meeting hours with skip level max 8 [SEE SPEC BELOW]
  20. Meeting hours with manager with 3 to 8 [SEE SPEC BELOW]

Custom metrics

  1. Meeting Hours 1 on 1: where Total attendees == 2
  2. Meeting Hours 1 on 1 with same level: All attendee's and/or recipient's where LevelDesignation == @RelativeToPerson AND Total attendees == 2
  3. Meeting hours 3 to 8: Total attendees >= 3 AND Total attendees <= 8
  4. Meeting hours with skip level max 8: Total attendees <= 8, using Meeting hours with skip level.
  5. Meeting hours with manager 3 to 8: Total attendees >= 3 AND Total attendees <= 8, using Meeting hours with manager. This is used to calculate small group meetings without manager by deducting this from Meeting hours for 3 to 8 attendees.

Table - 1

Table - 2

Table - 3

Notes

This report was generated on Dec 13 2021 .

There are 104 employees in this dataset.

Date ranges from 2021-01-03 to 2021-03-06.

There are 3 (estimated) HR attributes in the data: PersonId, IsActive, Organization

There are 103 active employees out of all in the dataset.

Total Runtime was: 0.28 minutes.